Lucas Rayala
Lucas Rayala
-
Poor Man's Datamesh
Prior to getting Datamesh, I devised a solution to transfer data from one page to another, without having matching columns. This process uses an intermediary sheet. It's kind of a pain to set up, but…8 · -
Re: Automate Workflow to Refresh 2 Sheets based on adding to another sheet
@Sherry Fox I cheated and asked ChatGPT. Here's a response, seems legit: Sherry, to automate the refresh and save process between Sheet A, Sheet B, and Sheet C without using the Smartsheet API, you c…1 · -
Re: Pulling data from one sheet and tabulating in another
Hi @K Goforth , it’s exactly the same formula, you just need a cross sheet column reference in place of the on-sheet column reference. When you create a formula, you’ll see the option to insert a cro…1 · -
Re: How to return a BLANK if we have a BLANK cell using a COUNTIFS formula
@Filippo, the most inelegant but dead simple thing to do is this: =IF(IFERROR(COUNTIFS(Reviewer:Reviewer, <>"", [Project Lead]:[Project Lead], [Project Lead]@row), "")=0, &q…1 · -
Flag Columns as Visible to “Admin Only”
Create a column attribute such that when selected only the sheet admins can see the column. For complex pages this will allow admins to work without disrupting general users, and admins won’t need to…4 ·
